Demystifying Data

06 - Data Visualisation

Purpose

Tell A Story

Total Exposure of MTPL Data by Region


Region Total Exposure
Centre 102712.90
Ile-de-France 30208.64
Provence-Alpes-Cotes-D'Azur 35790.32
Rhone-Alpes 45347.42
Other 144440.16

Total Exposure of MTPL Data by Region


Region Total Exposure
Centre 102,712.90
Ile-de-France 30,208.64
Provence-Alpes-Cotes-D'Azur 35,790.32
Rhone-Alpes 45,347.42
Other 144,440.16

Chart Types

Line plots


Scatter plots

Histograms


Error lines

French Motor Third-Party Liability

CASdatasets


http://cas.uqam.ca/


https://github.com/dutangc/CASdatasets

Policy

IDpol ClaimNb Exposure VehPower VehAge DrivAge BonusMalus VehBrand VehGas Area Density Region
1 1 0.10 5 0 55 50 B12 Regular D 1217 Rhone-Alpes
3 1 0.77 5 0 55 50 B12 Regular D 1217 Rhone-Alpes
5 1 0.75 6 2 52 50 B12 Diesel B 54 Picardie
10 1 0.09 7 0 46 50 B12 Diesel B 76 Aquitaine
11 1 0.84 7 0 46 50 B12 Diesel B 76 Aquitaine


Claims

IDpol ClaimAmount
1552 995.20
1010996 1128.12
4024277 1851.11
4007252 1204.00
4046424 1204.00

678,013 Policy Rows


26,639 Claim Rows

Visualisation and Exploration

Claim Rates

Geospatial Data

Visualise Comparisons

Compare Region by Fuel Type

Compare Region by Vehicle Brand

Pie Charts

Exposure by Region

Region Total Exposure
Alsace 1,209.12
Aquitaine 14,322.17
Auvergne 2,322.88
Basse-Normandie 6,657.90
Bourgogne 5,025.36
Bretagne 27,753.46
Centre 102,712.90
Champagne-Ardenne 1,205.83
Corse 1,765.94
Franche-Comte 564.01
Haute-Normandie 3,177.68
Ile-de-France 30,208.64
Languedoc-Roussillon 14,736.10
Limousin 2,395.99
Midi-Pyrenees 7,020.11
Nord-Pas-de-Calais 19,611.75
Pays-de-la-Loire 21,934.03
Picardie 3,574.41
Poitou-Charentes 11,163.41
Provence-Alpes-Cotes-D'Azur 35,790.32
Rhone-Alpes 45,347.42

Aggregate Under 10%

Aggregate Under 5%

Summary

Book Suggestions

Thank You


mcooney@describedata.com


https://kaybenleroll.github.io/data_workshops/talk_cirdas_master_202311/